// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_MST_PRODUCT
// * CreateDate    : 2014-06-05 18:30:16
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:16
// * LastChanger   : 2014-06-05 18:30:16
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class MstProductTable : TableInfo
    {
		public const string C_TableName = "MST_PRODUCT";
		
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_PRODUCT_TYPE_ID = "PRODUCT_TYPE_ID";
		public const string C_PRODUCT_CODE = "PRODUCT_CODE";
		public const string C_PRODUCT_SPEC_IN = "PRODUCT_SPEC_IN";
		public const string C_PRODUCT_SPEC_OUT = "PRODUCT_SPEC_OUT";
		public const string C_PRODUCT_NAME = "PRODUCT_NAME";
		public const string C_SUGGEST_PRICE = "SUGGEST_PRICE";
		public const string C_MATERIAL = "MATERIAL";
		public const string C_WEIGHT = "WEIGHT";
		public const string C_SIZE = "SIZE";
		public const string C_DIAMETER_OUT = "DIAMETER_OUT";
		public const string C_DIAMETER_IN = "DIAMETER_IN";
		public const string C_LENGTH = "LENGTH";
		public const string C_UNIT = "UNIT";
		public const string C_MINOR_UNIT = "MINOR_UNIT";
		public const string C_MATERIAL_CODE = "MATERIAL_CODE";
		public const string C_TYPE_NAME = "TYPE_NAME";
		public const string C_TYPE_CODE = "TYPE_CODE";
		public const string C_STD_NAME = "STD_NAME";
		public const string C_STD_CODE = "STD_CODE";
		public const string C_ROOT_CODE_TYPE = "ROOT_CODE_TYPE";
		public const string C_STOCK_TYPE = "STOCK_TYPE";
		public const string C_VOLUME = "VOLUME";
		public const string C_UV = "UV";
		public const string C_ARER = "ARER";
		public const string C_UA = "UA";
		public const string C_BLUEPRINT_PATH = "BLUEPRINT_PATH";
		public const string C_PHOTO = "PHOTO";
		public const string C_DESCRIPTION = "DESCRIPTION";
		public const string C_DELETE_FLAG = "DELETE_FLAG";
		
		public MstProductTable()
        {
            _tableName = "MST_PRODUCT";
        }
		
		protected static MstProductTable _current;
        public static MstProductTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new MstProductTable();

            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", true, typeof(string)));
            _current.Add(C_PRODUCT_TYPE_ID, new ColumnInfo(C_PRODUCT_TYPE_ID,"ProductTypeId", false, typeof(string)));
            _current.Add(C_PRODUCT_CODE, new ColumnInfo(C_PRODUCT_CODE,"ProductCode", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_IN, new ColumnInfo(C_PRODUCT_SPEC_IN,"ProductSpecIn", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_OUT, new ColumnInfo(C_PRODUCT_SPEC_OUT,"ProductSpecOut", false, typeof(string)));
            _current.Add(C_PRODUCT_NAME, new ColumnInfo(C_PRODUCT_NAME,"ProductName", false, typeof(string)));
            _current.Add(C_SUGGEST_PRICE, new ColumnInfo(C_SUGGEST_PRICE,"SuggestPrice", false, typeof(decimal)));
            _current.Add(C_MATERIAL, new ColumnInfo(C_MATERIAL,"Material", false, typeof(string)));
            _current.Add(C_WEIGHT, new ColumnInfo(C_WEIGHT,"Weight", false, typeof(decimal)));
            _current.Add(C_SIZE, new ColumnInfo(C_SIZE,"Size", false, typeof(decimal)));
            _current.Add(C_DIAMETER_OUT, new ColumnInfo(C_DIAMETER_OUT,"DiameterOut", false, typeof(decimal)));
            _current.Add(C_DIAMETER_IN, new ColumnInfo(C_DIAMETER_IN,"DiameterIn", false, typeof(decimal)));
            _current.Add(C_LENGTH, new ColumnInfo(C_LENGTH,"Length", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT,"Unit", false, typeof(string)));
            _current.Add(C_MINOR_UNIT, new ColumnInfo(C_MINOR_UNIT,"MinorUnit", false, typeof(string)));
            _current.Add(C_MATERIAL_CODE, new ColumnInfo(C_MATERIAL_CODE,"MaterialCode", false, typeof(string)));
            _current.Add(C_TYPE_NAME, new ColumnInfo(C_TYPE_NAME,"TypeName", false, typeof(string)));
            _current.Add(C_TYPE_CODE, new ColumnInfo(C_TYPE_CODE,"TypeCode", false, typeof(string)));
            _current.Add(C_STD_NAME, new ColumnInfo(C_STD_NAME,"StdName", false, typeof(string)));
            _current.Add(C_STD_CODE, new ColumnInfo(C_STD_CODE,"StdCode", false, typeof(string)));
            _current.Add(C_ROOT_CODE_TYPE, new ColumnInfo(C_ROOT_CODE_TYPE,"RootCodeType", false, typeof(string)));
            _current.Add(C_STOCK_TYPE, new ColumnInfo(C_STOCK_TYPE,"StockType", false, typeof(int)));
            _current.Add(C_VOLUME, new ColumnInfo(C_VOLUME,"Volume", false, typeof(decimal)));
            _current.Add(C_UV, new ColumnInfo(C_UV,"Uv", false, typeof(string)));
            _current.Add(C_ARER, new ColumnInfo(C_ARER,"Arer", false, typeof(decimal)));
            _current.Add(C_UA, new ColumnInfo(C_UA,"Ua", false, typeof(string)));
            _current.Add(C_BLUEPRINT_PATH, new ColumnInfo(C_BLUEPRINT_PATH,"BlueprintPath", false, typeof(string)));
            _current.Add(C_PHOTO, new ColumnInfo(C_PHOTO,"Photo", false, typeof(byte[])));
            _current.Add(C_DESCRIPTION, new ColumnInfo(C_DESCRIPTION,"Description", false, typeof(string)));
            _current.Add(C_DELETE_FLAG, new ColumnInfo(C_DELETE_FLAG,"DeleteFlag", false, typeof(int)));
			
		}
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo PRODUCT_TYPE_ID
        {
            get { return this[C_PRODUCT_TYPE_ID]; }
        }
		
		public ColumnInfo PRODUCT_CODE
        {
            get { return this[C_PRODUCT_CODE]; }
        }
		
		public ColumnInfo PRODUCT_SPEC_IN
        {
            get { return this[C_PRODUCT_SPEC_IN]; }
        }
		
		public ColumnInfo PRODUCT_SPEC_OUT
        {
            get { return this[C_PRODUCT_SPEC_OUT]; }
        }
		
		public ColumnInfo PRODUCT_NAME
        {
            get { return this[C_PRODUCT_NAME]; }
        }
		
		public ColumnInfo SUGGEST_PRICE
        {
            get { return this[C_SUGGEST_PRICE]; }
        }
		
		public ColumnInfo MATERIAL
        {
            get { return this[C_MATERIAL]; }
        }
		
		public ColumnInfo WEIGHT
        {
            get { return this[C_WEIGHT]; }
        }
		
		public ColumnInfo SIZE
        {
            get { return this[C_SIZE]; }
        }
		
		public ColumnInfo DIAMETER_OUT
        {
            get { return this[C_DIAMETER_OUT]; }
        }
		
		public ColumnInfo DIAMETER_IN
        {
            get { return this[C_DIAMETER_IN]; }
        }
		
		public ColumnInfo LENGTH
        {
            get { return this[C_LENGTH]; }
        }
		
		public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }
		
		public ColumnInfo MINOR_UNIT
        {
            get { return this[C_MINOR_UNIT]; }
        }
		
		public ColumnInfo MATERIAL_CODE
        {
            get { return this[C_MATERIAL_CODE]; }
        }
		
		public ColumnInfo TYPE_NAME
        {
            get { return this[C_TYPE_NAME]; }
        }
		
		public ColumnInfo TYPE_CODE
        {
            get { return this[C_TYPE_CODE]; }
        }
		
		public ColumnInfo STD_NAME
        {
            get { return this[C_STD_NAME]; }
        }
		
		public ColumnInfo STD_CODE
        {
            get { return this[C_STD_CODE]; }
        }
		
		public ColumnInfo ROOT_CODE_TYPE
        {
            get { return this[C_ROOT_CODE_TYPE]; }
        }
		
		public ColumnInfo STOCK_TYPE
        {
            get { return this[C_STOCK_TYPE]; }
        }
		
		public ColumnInfo VOLUME
        {
            get { return this[C_VOLUME]; }
        }
		
		public ColumnInfo UV
        {
            get { return this[C_UV]; }
        }
		
		public ColumnInfo ARER
        {
            get { return this[C_ARER]; }
        }
		
		public ColumnInfo UA
        {
            get { return this[C_UA]; }
        }
		
		public ColumnInfo BLUEPRINT_PATH
        {
            get { return this[C_BLUEPRINT_PATH]; }
        }
		
		public ColumnInfo PHOTO
        {
            get { return this[C_PHOTO]; }
        }
		
		public ColumnInfo DESCRIPTION
        {
            get { return this[C_DESCRIPTION]; }
        }
		
		public ColumnInfo DELETE_FLAG
        {
            get { return this[C_DELETE_FLAG]; }
        }
		
		
		
	}
}

